using System;
using System.Collections.Generic;
using System.Text;
using System.Data;
using System.Drawing;
namespace Test.Support {
	class BulkRfTransfer {
		static void MainX() {


			//KnownColor.
			Color c=Color.FromName("orange");
			if(c.IsKnownColor&&"orange"==c.Name)
				Console.WriteLine("OK");
			//Color.White;

			return;
			//      DAL src=new DAL("(local)\\sql2012","DirectoryTest");
			//      DataTable srcT=src.Query("select * from BulkPutaway(nolock) order by id");
			//      string create=@"create table BulkPutaway(id int identity primary key,inserted datetime default getdate(),
			//bdc varchar(31),sku varchar(20),bonus varchar(3),location varchar(7),qty int,status char)";
			//      Console.WriteLine(src.Scalar("select count(*)from BulkPutaway(nolock)"));
			//      //DAL dest=new DAL("pon-wpsq16-db","Directory");
			//      //dest.NonQry(create);
			//      DAL dest=new DAL("pon-wdsq01-db","DirectoryTest");
			//      dest.NonQry("truncate table BulkPutaway");
			//      foreach(DataRow row in srcT.Rows)
			//      {
			//        DateTime dat=(DateTime)row["inserted"];

			//        dest.NonQry("SET IDENTITY_INSERT BulkPutaway ON INSERT INTO BulkPutaway(inserted,bdc,sku,bonus,location,qty,status,id) VALUES(convert(DateTime,'{0:yyyy-MM-dd HH:mm:ss.fff}',21),'{1}','{2}','{3}','{4}',{5},'{6}',{7})",dat,row["bdc"],row["sku"],row["bonus"],row["location"],row["qty"],row["status"],row["id"]);
			//        //dest.NonQry("INSERT INTO BulkPutaway(inserted,bdc,sku,bonus,location,qty,status) VALUES(convert(DateTime,'{0:yyyy-MM-dd HH:mm:ss.fff}',21),'{1}','{2}','{3}','{4}',{5},'{6}')",dat,row["bdc"],row["sku"],row["bonus"],row["location"],row["qty"],row["status"]);
			//      }


			//      Console.WriteLine(dest.Scalar("select count(*)from BulkPutaway(nolock)"));




		}
	}
}
